<template>
	<view>
		<view class="uni-header">
			<view class="uni-group">
				<view class="uni-title"></view>
				<view class="uni-sub-title"></view>
			</view>
			<view class="uni-group">
				<input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
				<button class="uni-button" type="default" size="mini" @click="search">搜索</button>
				<button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
				<button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
					@click="delTable">批量删除</button>
				<download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
					:type="exportExcel.type" :name="exportExcel.filename">
					<button class="uni-button" type="primary" size="mini">导出 Excel</button>
				</download-excel>
			</view>
		</view>
		<view class="uni-container">
			<unicloud-db ref="udb" collection="opendb-news-articles,opendb-news-categories"
				field="user,category_id{name as text},title,content,excerpt,source_from,article_status,view_count,like_count,is_sticky,is_essence,comment_status,comment_count,last_comment_user_id,avatar,publish_date,publish_ip,last_modify_date,last_modify_ip,mode"
				:where="where" page-data="replace" :orderby="orderby" :getcount="true" :page-size="options.pageSize"
				:page-current="options.pageCurrent" v-slot:default="{data,pagination,loading,error,options}"
				:options="options" loadtime="manual" @load="onqueryload">
				<uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe
					type="selection" @selection-change="selectionChange">
					<uni-tr>
						<!-- <uni-th align="center" sortable @sort-change="sortChange($event, 'user_id')">user_id</uni-th> -->
						<uni-th align="center" sortable @sort-change="sortChange($event, 'user')">文章作者</uni-th>
						<uni-th align="center">分类</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'title')"
							sortable @sort-change="sortChange($event, 'title')">标题</uni-th>
						<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'content')" sortable @sort-change="sortChange($event, 'content')">文章内容</uni-th> -->
						<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'excerpt')" sortable @sort-change="sortChange($event, 'excerpt')">摘要</uni-th> -->
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'source_from')"
							sortable @sort-change="sortChange($event, 'source_from')">来源</uni-th>
						<uni-th align="center" filter-type="select"
							:filter-data="options.filterData.article_status_localdata"
							@filter-change="filterChange($event, 'article_status')">文章状态</uni-th>
						<uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'view_count')"
							sortable @sort-change="sortChange($event, 'view_count')">阅读量</uni-th>
						<!-- <uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'like_count')" sortable @sort-change="sortChange($event, 'like_count')">点赞数</uni-th> -->
						<uni-th align="center" sortable @sort-change="sortChange($event, 'is_sticky')">是否置顶</uni-th>
						<!-- <uni-th align="center" sortable @sort-change="sortChange($event, 'is_essence')">阅读加精</uni-th> -->
						<!-- <uni-th align="center" filter-type="select" :filter-data="options.filterData.comment_status_localdata" @filter-change="filterChange($event, 'comment_status')">开放评论</uni-th> -->
						<!-- <uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'comment_count')" sortable @sort-change="sortChange($event, 'comment_count')">评论数量</uni-th> -->
						<!-- <uni-th align="center" sortable @sort-change="sortChange($event, 'last_comment_user_id')">last_comment_user_id</uni-th> -->
						<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'avatar')" sortable @sort-change="sortChange($event, 'avatar')">封面大图</uni-th> -->
						<uni-th align="center" filter-type="timestamp"
							@filter-change="filterChange($event, 'publish_date')" sortable
							@sort-change="sortChange($event, 'publish_date')">发表时间</uni-th>
						<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'publish_ip')" sortable @sort-change="sortChange($event, 'publish_ip')">发布文章时IP地址</uni-th> -->
						<!-- <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'last_modify_date')" sortable @sort-change="sortChange($event, 'last_modify_date')">最后修改时间</uni-th> -->
						<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'last_modify_ip')" sortable @sort-change="sortChange($event, 'last_modify_ip')">last_modify_ip</uni-th> -->
						<!-- <uni-th align="center" sortable @sort-change="sortChange($event, 'mode')">排版显示模式</uni-th> -->
						<uni-th align="center">操作</uni-th>
					</uni-tr>
					<uni-tr v-for="(item,index) in data" :key="index">
						<!-- <uni-td align="center">{{item.user_id && item.user_id[0] && item.user_id[0].user_name}}</uni-td> -->
						<uni-td align="center">{{item.user}}</uni-td>
						<uni-td align="center">{{item.category_id && item.category_id[0] && item.category_id[0].text}}
						</uni-td>
						<uni-td align="center">{{item.title}}</uni-td>
						<!-- <uni-td align="center">{{item.content}}</uni-td> -->
						<!-- <uni-td align="center">{{item.excerpt}}</uni-td> -->
						<uni-td align="center">{{item.source_from}}</uni-td>
						<uni-td align="center">{{options.article_status_valuetotext[item.article_status]}}</uni-td>
						<uni-td align="center">{{item.view_count}}</uni-td>
						<!-- <uni-td align="center">{{item.like_count}}</uni-td> -->
						<uni-td align="center">{{item.is_sticky == true ? '✅' : '❌'}}</uni-td>
						<!-- <uni-td align="center">{{item.is_essence == true ? '✅' : '❌'}}</uni-td> -->
						<!-- <uni-td align="center">{{options.comment_status_valuetotext[item.comment_status]}}</uni-td> -->
						<!-- <uni-td align="center">{{item.comment_count}}</uni-td> -->
						<!-- <uni-td align="center">{{item.last_comment_user_id}}</uni-td> -->
						<!--            <uni-td align="center">
              <uni-link :href="item.avatar" :download="item.avatar" :text="item.avatar"></uni-link>
            </uni-td> -->
						<uni-td align="center">
							<uni-dateformat :threshold="[0, 0]" :date="item.publish_date"></uni-dateformat>
						</uni-td>
						<!-- <uni-td align="center">{{item.publish_ip}}</uni-td> -->
						<!--            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.last_modify_date"></uni-dateformat>
            </uni-td> -->
						<!-- <uni-td align="center">{{item.last_modify_ip}}</uni-td> -->
						<!-- <uni-td align="center">{{item.mode}}</uni-td> -->
						<uni-td align="center">
							<view class="uni-group">
								<button @click="navigateTo('./edit?id='+item._id, false)" class="uni-button" size="mini"
									type="primary">修改</button>
								<button @click="confirmDelete(item._id)" class="uni-button" size="mini"
									type="warn">删除</button>
							</view>
						</uni-td>
					</uni-tr>
				</uni-table>
				<view class="uni-pagination-box">
					<uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current"
						:total="pagination.count" @change="onPageChanged" />
				</view>
			</unicloud-db>
		</view>
	</view>
</template>

<script>
	import {
		enumConverter,
		filterToWhere
	} from '../../js_sdk/validator/opendb-news-articles.js';
	const db = uniCloud.database()
	// 表查询配置
	const dbOrderBy = '' // 排序字段
	const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
	// 分页配置
	const pageSize = 20
	const pageCurrent = 1
	const orderByMapping = {
		"ascending": "asc",
		"descending": "desc"
	}
	export default {
		data() {
			return {
				query: '',
				where: '',
				orderby: dbOrderBy,
				orderByFieldName: "",
				selectedIndexs: [],
				options: {
					pageSize,
					pageCurrent,
					filterData: {
						"article_status_localdata": [{
								"text": "草稿箱",
								"value": 0
							},
							{
								"text": "已发布",
								"value": 1
							}
						],
						"comment_status_localdata": [{
								"value": 0,
								"text": "关闭"
							},
							{
								"value": 1,
								"text": "开放"
							}
						]
					},
					...enumConverter
				},
				imageStyles: {
					width: 64,
					height: 64
				},
				exportExcel: {
					"filename": "opendb-news-articles.xls",
					"type": "xls",
					"fields": {
						"user_id": "user_id",
						"文章作者": "user",
						"分类": "category_id",
						"标题": "title",
						"文章内容": "content",
						"文章摘录": "excerpt",
						"来源": "source_from",
						"文章状态": "article_status",
						"阅读数量": "view_count",
						"点赞数": "like_count",
						"是否置顶": "is_sticky",
						"阅读加精": "is_essence",
						"开放评论": "comment_status",
						"评论数量": "comment_count",
						"last_comment_user_id": "last_comment_user_id",
						"封面大图": "avatar",
						"发表时间": "publish_date",
						"发布文章时IP地址": "publish_ip",
						"最后修改时间": "last_modify_date",
						"last_modify_ip": "last_modify_ip",
						"排版显示模式": "mode"
					}
				},
				exportExcelData: []
			}
		},
		onLoad() {
			this._filter = {}
		},
		onReady() {
			this.$refs.udb.loadData()
		},
		methods: {
			onqueryload(data) {
				this.exportExcelData = data
			},
			getWhere() {
				const query = this.query.trim()
				if (!query) {
					return ''
				}
				const queryRe = new RegExp(query, 'i')
				return dbSearchFields.map(name => queryRe + '.test(' + name + ')')
				.join(' || ')
			},
			search() {
				const newWhere = this.getWhere()
				this.where = newWhere
				this.$nextTick(() => {
					this.loadData()
				})
			},
			loadData(clear = true) {
				this.$refs.udb.loadData({
					clear
				})
			},
			onPageChanged(e) {
				this.selectedIndexs.length = 0
				this.$refs.table.clearSelection()
				this.$refs.udb.loadData({
					current: e.current
				})
			},
			navigateTo(url, clear) {
				// clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
				uni.navigateTo({
					url,
					events: {
						refreshData: () => {
							this.loadData(clear)
						}
					}
				})
			},
			// 多选处理
			selectedItems() {
				var dataList = this.$refs.udb.dataList
				return this.selectedIndexs.map(i => dataList[i]._id)
			},
			// 批量删除
			delTable() {
				this.$refs.udb.remove(this.selectedItems(), {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			// 多选
			selectionChange(e) {
				this.selectedIndexs = e.detail.index
			},
			confirmDelete(id) {
				this.$refs.udb.remove(id, {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			sortChange(e, name) {
				this.orderByFieldName = name;
				if (e.order) {
					this.orderby = name + ' ' + orderByMapping[e.order]
				} else {
					this.orderby = ''
				}
				this.$refs.table.clearSelection()
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			},
			filterChange(e, name) {
				this._filter[name] = {
					type: e.filterType,
					value: e.filter
				}
				let newWhere = filterToWhere(this._filter, db.command)
				if (Object.keys(newWhere)
				.length) {
					this.where = newWhere
				} else {
					this.where = ''
				}
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			}
		}
	}

</script>

<style>
</style>
